package press.xiang.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import press.xiang.entity.Store;

import java.util.List;

/**
 * 用户dao层
 * @description: TODO
 * @author xiang
 * @date 2022/4/21 6:33 下午
 * @version 1.0
 */
public interface StoreMapper extends BaseMapper<Store> {

    @Update("truncate table tabu_store")
    void truncateStore();


    @Select("select name,long_and_lat from tabu_store where id in (select store_id from tabu_commodity  where name = #{name} )order by name")
    List<Store> getStorePathByCommodityName(@Param("name") String name);


}
